﻿// =================================================================== 
// 项目说明
//====================================================================
// @Copy Right 2006-2008
// 文件： T_CUSTOMER.cs
// 项目名称：Lovol 
// 创建时间：2011/8/26
// 负责人：
// ===================================================================
using System;
using System.Collections.Generic;
using System.Text;
using DP.Data.OracleClient;
using System.Configuration;
using DP.Data.SqlClient;
namespace CRM.Entity
{
    /// <summary>
    ///T_CUSTOMER数据实体
    /// </summary>
    [Serializable]
    [OracleTable(TableName = "T_CUSTOMER", TableOrView = DP.Data.Common.TableType.Table, ConnectionStringKey = "SQLConnString")]
    [SqlTable(TableName = "T_CUSTOMER", TableOrView = DP.Data.Common.TableType.Table, ConnectionStringKey = "SQLConnString")]
    public class T_CUSTOMER_Entity
    {
        #region 变量定义
        ///<summary>
        ///客户编号
        ///</summary>
        private string _cUSTOMERID;
        ///<summary>
        ///客户姓名
        ///</summary>
        private string _cUSTOMERNAME = String.Empty;
        ///<summary>
        ///首选联系号码
        ///</summary>
        private string _fIRSTCONTACTTEL = String.Empty;
        ///<summary>
        ///首选联系方式
        ///</summary>
        private string _fIRSTCONTACTTYPE = String.Empty;
        ///<summary>
        ///手机号码
        ///</summary>
        private string _mOBILEPHONE = String.Empty;
        ///<summary>
        ///座机号码
        ///</summary>
        private string _hOMEPHONE = String.Empty;
        ///<summary>
        ///详细地址
        ///</summary>
        private string _aDDRESS = String.Empty;
        ///<summary>
        ///国家
        ///</summary>
        private string _cOUNTRY = String.Empty;
        ///<summary>
        ///省份
        ///</summary>
        private string _pROVINCE = String.Empty;
        ///<summary>
        ///地级市
        ///</summary>
        private string _pREFECTURECITY = String.Empty;
        ///<summary>
        ///区/县/市
        ///</summary>
        private string _cITY = String.Empty;
        ///<summary>
        ///乡/镇/街道
        ///</summary>
        private string _vILLAGETOWN = String.Empty;
        ///<summary>
        ///村
        ///</summary>
        private string _vILLAGE = String.Empty;
        ///<summary>
        ///组/队
        ///</summary>
        private string _gROUPTEAM = String.Empty;
        ///<summary>
        ///客户群
        ///</summary>
        private string _cUSTOMERBASE = String.Empty;
        ///<summary>
        ///客户类型
        ///</summary>
        private string _cUSTOMERTYPE = String.Empty;
        ///<summary>
        ///客户等级
        ///</summary>
        private string _cUSTOMERLEVEL = String.Empty;
        ///<summary>
        ///特殊类型
        ///</summary>
        private string _sPECIALTYPE = String.Empty;
        ///<summary>
        ///大客户类型
        ///</summary>
        private string _bIGCUSTOMERTYPE = String.Empty;
        ///<summary>
        ///状态
        ///</summary>
        private long? _sTATUS;
        ///<summary>
        ///黑名单红名单
        ///</summary>
        private long? _sPECIALLIST;
        ///<summary>
        ///证件号码
        ///</summary>
        private string _iDNUMBER = String.Empty;
        ///<summary>
        ///网站地址
        ///</summary>
        private string _uRL = String.Empty;
        ///<summary>
        ///邮件地址
        ///</summary>
        private string _eMAIL = String.Empty;
        ///<summary>
        ///邮编
        ///</summary>
        private string _zIPCODE = String.Empty;
        ///<summary>
        ///传真
        ///</summary>
        private string _fAX = String.Empty;
        ///<summary>
        ///创建时间
        ///</summary>
        private DateTime? _cREATETIME;
        ///<summary>
        ///创建人编号
        ///</summary>
        private long? _cREATEPEOPLEID;
        ///<summary>
        ///创建人
        ///</summary>
        private string _cREATEPEOPLE = String.Empty;
        ///<summary>
        ///最后修改人编号
        ///</summary>
        private long? _lASTMODIFYPEOPLEID;
        ///<summary>
        ///最后修改人
        ///</summary>
        private string _lASTMODIFYPEOPLE = String.Empty;
        ///<summary>
        ///最后修改时间
        ///</summary>
        private DateTime? _lASTMODIFYTIME;
        ///<summary>
        ///备注
        ///</summary>
        private string _rEMARK = String.Empty;
        ///<summary>
        ///记录状态变更日志
        ///</summary>
        private string _sTATUSLOG = String.Empty;
        ///<summary>
        ///时间戳
        ///</summary>
        private DateTime? _fTIMESTAMP;
        ///<summary>
        ///年龄
        ///</summary>
        private long? _aGE;
        ///<summary>
        ///是否接受短信
        ///</summary>
        private long? _iSACCEPTSMS;
        ///<summary>
        ///是否接受资料
        ///</summary>
        private long? _iSACCEPTINFORMATION;
        ///<summary>
        ///生日
        ///</summary>
        private DateTime? _bIRTHDATE;
        ///<summary>
        ///经销商编号
        ///</summary>
        private long? _dEALERID;
        ///<summary>
        ///经销商名称
        ///</summary>
        private string _dEALERNAME = String.Empty;
        ///<summary>
        ///经销商代码
        ///</summary>
        private string _dEALERCODE = String.Empty;
        ///<summary>
        ///组织名称
        ///</summary>
        private string _oRGNAME = String.Empty;
        ///<summary>
        ///区域名称
        ///</summary>
        private string _zONENAME = String.Empty;
        ///<summary>
        ///事业部编号
        ///</summary>
        private long? _bUSINESSDIVISIONID;
        ///<summary>
        ///事业部名称
        ///</summary>
        private string _bUSINESSDIVISIONNAME = String.Empty;
        ///<summary>
        ///事业部代码
        ///</summary>
        private string _bUSINESSDIVISIONCODE = String.Empty;
        ///<summary>
        ///成为客户日期
        ///</summary>
        private DateTime? _bECOMEDATE;
        ///<summary>
        ///购买台数
        ///</summary>
        private long? _pURCHASENUMBER;
        ///<summary>
        ///客户代码
        ///</summary>
        private string _cUSTOMERCODE = String.Empty;
        #endregion

        #region 构造函数
        ///<summary>
        ///
        ///</summary>
        public T_CUSTOMER_Entity()
        {

        }
        #endregion

        #region 公共属性

        ///<summary>
        ///客户编号
        ///</summary>		
        [OracleColumn(IncrementPrimaryKey = false, PrimaryKey = true)]
        [SqlColumn(IncrementPrimaryKey = false, PrimaryKey = true)]
        public string CUSTOMERID
        {
            get { return _cUSTOMERID; }
            set
            {
                _cUSTOMERID = value;
            }

        }

        ///<summary>
        ///客户姓名
        ///</summary>		
        public string CUSTOMERNAME
        {
            get { return _cUSTOMERNAME; }
            set
            {
                _cUSTOMERNAME = value;
            }

        }

        ///<summary>
        ///首选联系号码
        ///</summary>		
        public string FIRSTCONTACTTEL
        {
            get { return _fIRSTCONTACTTEL; }
            set
            {
                _fIRSTCONTACTTEL = value;
            }

        }

        ///<summary>
        ///首选联系方式
        ///</summary>		
        public string FIRSTCONTACTTYPE
        {
            get { return _fIRSTCONTACTTYPE; }
            set
            {
                _fIRSTCONTACTTYPE = value;
            }

        }

        ///<summary>
        ///手机号码
        ///</summary>		
        public string MOBILEPHONE
        {
            get { return _mOBILEPHONE; }
            set
            {
                _mOBILEPHONE = value;
            }

        }

        ///<summary>
        ///座机号码
        ///</summary>		
        public string HOMEPHONE
        {
            get { return _hOMEPHONE; }
            set
            {
                _hOMEPHONE = value;
            }

        }

        ///<summary>
        ///详细地址
        ///</summary>		
        public string ADDRESS
        {
            get { return _aDDRESS; }
            set
            {
                _aDDRESS = value;
            }

        }

        ///<summary>
        ///国家
        ///</summary>		
        public string COUNTRY
        {
            get { return _cOUNTRY; }
            set
            {
                _cOUNTRY = value;
            }

        }

        ///<summary>
        ///省份
        ///</summary>		
        public string PROVINCE
        {
            get { return _pROVINCE; }
            set
            {
                _pROVINCE = value;
            }

        }

        ///<summary>
        ///地级市
        ///</summary>		
        public string PREFECTURECITY
        {
            get { return _pREFECTURECITY; }
            set
            {
                _pREFECTURECITY = value;
            }

        }

        ///<summary>
        ///区/县/市
        ///</summary>		
        public string CITY
        {
            get { return _cITY; }
            set
            {
                _cITY = value;
            }

        }

        ///<summary>
        ///乡/镇/街道
        ///</summary>		
        public string VILLAGETOWN
        {
            get { return _vILLAGETOWN; }
            set
            {
                _vILLAGETOWN = value;
            }

        }

        ///<summary>
        ///村
        ///</summary>		
        public string VILLAGE
        {
            get { return _vILLAGE; }
            set
            {
                _vILLAGE = value;
            }

        }

        ///<summary>
        ///组/队
        ///</summary>		
        public string GROUPTEAM
        {
            get { return _gROUPTEAM; }
            set
            {
                _gROUPTEAM = value;
            }

        }

        ///<summary>
        ///客户群
        ///</summary>		
        public string CUSTOMERBASE
        {
            get { return _cUSTOMERBASE; }
            set
            {
                _cUSTOMERBASE = value;
            }

        }

        ///<summary>
        ///客户类型
        ///</summary>		
        public string CUSTOMERTYPE
        {
            get { return _cUSTOMERTYPE; }
            set
            {
                _cUSTOMERTYPE = value;
            }

        }

        ///<summary>
        ///客户等级
        ///</summary>		
        public string CUSTOMERLEVEL
        {
            get { return _cUSTOMERLEVEL; }
            set
            {
                _cUSTOMERLEVEL = value;
            }

        }

        ///<summary>
        ///特殊类型
        ///</summary>		
        public string SPECIALTYPE
        {
            get { return _sPECIALTYPE; }
            set
            {
                _sPECIALTYPE = value;
            }

        }

        ///<summary>
        ///大客户类型
        ///</summary>		
        public string BIGCUSTOMERTYPE
        {
            get { return _bIGCUSTOMERTYPE; }
            set
            {
                _bIGCUSTOMERTYPE = value;
            }

        }

        ///<summary>
        ///状态
        ///</summary>		
        public long? STATUS
        {
            get { return _sTATUS; }
            set { _sTATUS = value; }

        }

        ///<summary>
        ///黑名单红名单
        ///</summary>		
        public long? SPECIALLIST
        {
            get { return _sPECIALLIST; }
            set { _sPECIALLIST = value; }

        }

        ///<summary>
        ///证件号码
        ///</summary>		
        public string IDNUMBER
        {
            get { return _iDNUMBER; }
            set
            {
                _iDNUMBER = value;
            }

        }

        ///<summary>
        ///网站地址
        ///</summary>		
        public string URL
        {
            get { return _uRL; }
            set
            {
                _uRL = value;
            }

        }

        ///<summary>
        ///邮件地址
        ///</summary>		
        public string EMAIL
        {
            get { return _eMAIL; }
            set
            {
                _eMAIL = value;
            }

        }

        ///<summary>
        ///邮编
        ///</summary>		
        public string ZIPCODE
        {
            get { return _zIPCODE; }
            set
            {
                _zIPCODE = value;
            }

        }

        ///<summary>
        ///传真
        ///</summary>		
        public string FAX
        {
            get { return _fAX; }
            set
            {
                _fAX = value;
            }

        }

        ///<summary>
        ///创建时间
        ///</summary>		
        public DateTime? CREATETIME
        {
            get { return _cREATETIME; }
            set { _cREATETIME = value; }

        }

        ///<summary>
        ///创建人编号
        ///</summary>		
        public long? CREATEPEOPLEID
        {
            get { return _cREATEPEOPLEID; }
            set { _cREATEPEOPLEID = value; }

        }

        ///<summary>
        ///创建人
        ///</summary>		
        public string CREATEPEOPLE
        {
            get { return _cREATEPEOPLE; }
            set
            {
                _cREATEPEOPLE = value;
            }

        }

        ///<summary>
        ///最后修改人编号
        ///</summary>		
        public long? LASTMODIFYPEOPLEID
        {
            get { return _lASTMODIFYPEOPLEID; }
            set { _lASTMODIFYPEOPLEID = value; }

        }

        ///<summary>
        ///最后修改人
        ///</summary>		
        public string LASTMODIFYPEOPLE
        {
            get { return _lASTMODIFYPEOPLE; }
            set
            {
                _lASTMODIFYPEOPLE = value;
            }

        }

        ///<summary>
        ///最后修改时间
        ///</summary>		
        public DateTime? LASTMODIFYTIME
        {
            get { return _lASTMODIFYTIME; }
            set { _lASTMODIFYTIME = value; }

        }

        ///<summary>
        ///备注
        ///</summary>		
        public string REMARK
        {
            get { return _rEMARK; }
            set
            {
                _rEMARK = value;
            }

        }

        ///<summary>
        ///记录状态变更日志
        ///</summary>		
        public string STATUSLOG
        {
            get { return _sTATUSLOG; }
            set
            {
                _sTATUSLOG = value;
            }

        }

        ///<summary>
        ///时间戳
        ///</summary>		
        public DateTime? FTIMESTAMP
        {
            get { return _fTIMESTAMP; }
            set { _fTIMESTAMP = value; }

        }

        ///<summary>
        ///年龄
        ///</summary>		
        public long? AGE
        {
            get { return _aGE; }
            set { _aGE = value; }

        }

        ///<summary>
        ///是否接受短信
        ///</summary>		
        public long? ISACCEPTSMS
        {
            get { return _iSACCEPTSMS; }
            set { _iSACCEPTSMS = value; }

        }

        ///<summary>
        ///是否接受资料
        ///</summary>		
        public long? ISACCEPTINFORMATION
        {
            get { return _iSACCEPTINFORMATION; }
            set { _iSACCEPTINFORMATION = value; }

        }

        ///<summary>
        ///生日
        ///</summary>		
        public DateTime? BIRTHDATE
        {
            get { return _bIRTHDATE; }
            set { _bIRTHDATE = value; }

        }

        ///<summary>
        ///经销商编号
        ///</summary>		
        public long? DEALERID
        {
            get { return _dEALERID; }
            set { _dEALERID = value; }

        }

        ///<summary>
        ///经销商名称
        ///</summary>		
        public string DEALERNAME
        {
            get { return _dEALERNAME; }
            set
            {
                _dEALERNAME = value;
            }

        }

        ///<summary>
        ///经销商代码
        ///</summary>		
        public string DEALERCODE
        {
            get { return _dEALERCODE; }
            set
            {
                _dEALERCODE = value;
            }

        }

        ///<summary>
        ///组织名称
        ///</summary>		
        public string ORGNAME
        {
            get { return _oRGNAME; }
            set
            {
                _oRGNAME = value;
            }

        }

        ///<summary>
        ///区域名称
        ///</summary>		
        public string ZONENAME
        {
            get { return _zONENAME; }
            set
            {
                _zONENAME = value;
            }

        }

        ///<summary>
        ///事业部编号
        ///</summary>		
        public long? BUSINESSDIVISIONID
        {
            get { return _bUSINESSDIVISIONID; }
            set { _bUSINESSDIVISIONID = value; }

        }

        ///<summary>
        ///事业部名称
        ///</summary>		
        public string BUSINESSDIVISIONNAME
        {
            get { return _bUSINESSDIVISIONNAME; }
            set
            {
                _bUSINESSDIVISIONNAME = value;
            }

        }

        ///<summary>
        ///事业部代码
        ///</summary>		
        public string BUSINESSDIVISIONCODE
        {
            get { return _bUSINESSDIVISIONCODE; }
            set
            {
                _bUSINESSDIVISIONCODE = value;
            }

        }

        ///<summary>
        ///成为客户日期
        ///</summary>		
        public DateTime? BECOMEDATE
        {
            get { return _bECOMEDATE; }
            set { _bECOMEDATE = value; }

        }

        ///<summary>
        ///购买台数
        ///</summary>		
        public long? PURCHASENUMBER
        {
            get { return _pURCHASENUMBER; }
            set { _pURCHASENUMBER = value; }

        }

        ///<summary>
        ///客户代码
        ///</summary>		
        public string CUSTOMERCODE
        {
            get { return _cUSTOMERCODE; }
            set
            {
                _cUSTOMERCODE = value;
            }

        }


        #endregion

    }
}
